In [1]:
pip install -U pandas-profiling
Defaulting to user installation because normal site-packages is not writeable
Collecting pandas-profiling
  Downloading pandas_profiling-3.6.6-py2.py3-none-any.whl (324 kB)
Collecting ydata-profiling
  Downloading ydata_profiling-4.3.1-py2.py3-none-any.whl (352 kB)
Requirement already satisfied: scipy<1.11,>=1.4.1 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (1.7.3)
Collecting wordcloud>=1.9.1
  Downloading wordcloud-1.9.2-cp39-cp39-win_amd64.whl (153 kB)
Requirement already satisfied: seaborn<0.13,>=0.10.1 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (0.11.2)
Collecting pydantic<2,>=1.8.1
  Downloading pydantic-1.10.11-cp39-cp39-win_amd64.whl (2.2 MB)
Requirement already satisfied: PyYAML<6.1,>=5.0.0 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (6.0)
Collecting dacite>=1.8
  Downloading dacite-1.8.1-py3-none-any.whl (14 kB)
Requirement already satisfied: numpy<1.24,>=1.16.0 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (1.21.5)
Requirement already satisfied: statsmodels<1,>=0.13.2 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (0.13.2)
Requirement already satisfied: matplotlib<4,>=3.2 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (3.5.1)
Requirement already satisfied: tqdm<5,>=4.48.2 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (4.64.0)
Requirement already satisfied: pandas!=1.4.0,<2.1,>1.1 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (1.4.2)
Collecting typeguard<3,>=2.13.2
  Downloading typeguard-2.13.3-py3-none-any.whl (17 kB)
Collecting imagehash==4.3.1
  Downloading ImageHash-4.3.1-py2.py3-none-any.whl (296 kB)
Collecting htmlmin==0.1.12
  Downloading htmlmin-0.1.12.tar.gz (19 kB)
Collecting multimethod<2,>=1.4
  Downloading multimethod-1.9.1-py3-none-any.whl (10 kB)
Requirement already satisfied: requests<3,>=2.24.0 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (2.27.1)
Collecting visions[type_image_path]==0.7.5
  Downloading visions-0.7.5-py3-none-any.whl (102 kB)
Requirement already satisfied: jinja2<3.2,>=2.11.1 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (2.11.3)
Collecting phik<0.13,>=0.11.1
  Downloading phik-0.12.3-cp39-cp39-win_amd64.whl (663 kB)
Requirement already satisfied: PyWavelets in c:\programdata\anaconda3\lib\site-packages (from imagehash==4.3.1->ydata-profiling->pandas-profiling) (1.3.0)
Requirement already satisfied: pillow in c:\programdata\anaconda3\lib\site-packages (from imagehash==4.3.1->ydata-profiling->pandas-profiling) (9.0.1)
Requirement already satisfied: networkx>=2.4 in c:\programdata\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->ydata-profiling->pandas-profiling) (2.7.1)
Collecting tangled-up-in-unicode>=0.0.4
  Downloading tangled_up_in_unicode-0.2.0-py3-none-any.whl (4.7 MB)
Requirement already satisfied: attrs>=19.3.0 in c:\programdata\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->ydata-profiling->pandas-profiling) (21.4.0)
Requirement already satisfied: MarkupSafe>=0.23 in c:\programdata\anaconda3\lib\site-packages (from jinja2<3.2,>=2.11.1->ydata-profiling->pandas-profiling) (2.0.1)
Requirement already satisfied: packaging>=20.0 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (21.3)
Requirement already satisfied: cycler>=0.10 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (0.11.0)
Requirement already satisfied: kiwisolver>=1.0.1 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (1.3.2)
Requirement already satisfied: pyparsing>=2.2.1 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (3.0.4)
Requirement already satisfied: fonttools>=4.22.0 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (4.25.0)
Requirement already satisfied: python-dateutil>=2.7 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (2.8.2)
Requirement already satisfied: pytz>=2020.1 in c:\programdata\anaconda3\lib\site-packages (from pandas!=1.4.0,<2.1,>1.1->ydata-profiling->pandas-profiling) (2021.3)
Requirement already satisfied: joblib>=0.14.1 in c:\programdata\anaconda3\lib\site-packages (from phik<0.13,>=0.11.1->ydata-profiling->pandas-profiling) (1.1.0)
Collecting typing-extensions>=4.2.0
  Downloading typing_extensions-4.7.1-py3-none-any.whl (33 kB)
Requirement already satisfied: six>=1.5 in c:\programdata\anaconda3\lib\site-packages (from python-dateutil>=2.7->matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (1.16.0)
Requirement already satisfied: certifi>=2017.4.17 in c:\programdata\anaconda3\lib\site-packages (from requests<3,>=2.24.0->ydata-profiling->pandas-profiling) (2021.10.8)
Requirement already satisfied: idna<4,>=2.5 in c:\programdata\anaconda3\lib\site-packages (from requests<3,>=2.24.0->ydata-profiling->pandas-profiling) (3.3)
Requirement already satisfied: charset-normalizer~=2.0.0 in c:\programdata\anaconda3\lib\site-packages (from requests<3,>=2.24.0->ydata-profiling->pandas-profiling) (2.0.4)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\programdata\anaconda3\lib\site-packages (from requests<3,>=2.24.0->ydata-profiling->pandas-profiling) (1.26.9)
Requirement already satisfied: patsy>=0.5.2 in c:\programdata\anaconda3\lib\site-packages (from statsmodels<1,>=0.13.2->ydata-profiling->pandas-profiling) (0.5.2)
Requirement already satisfied: colorama in c:\programdata\anaconda3\lib\site-packages (from tqdm<5,>=4.48.2->ydata-profiling->pandas-profiling) (0.4.4)
Building wheels for collected packages: htmlmin
  Building wheel for htmlmin (setup.py): started
  Building wheel for htmlmin (setup.py): still running...
  Building wheel for htmlmin (setup.py): finished with status 'done'
  Created wheel for htmlmin: filename=htmlmin-0.1.12-py3-none-any.whl size=27096 sha256=dea19bf5d68ddb9d2f27897f127a6e488a7958bcc3b9c9de44d31a995b9510af
  Stored in directory: c:\users\gilda.tahani\appdata\local\pip\cache\wheels\1d\05\04\c6d7d3b66539d9e659ac6dfe81e2d0fd4c1a8316cc5a403300
Successfully built htmlmin
Installing collected packages: tangled-up-in-unicode, multimethod, visions, typing-extensions, imagehash, wordcloud, typeguard, pydantic, phik, htmlmin, dacite, ydata-profiling, pandas-profiling
Successfully installed dacite-1.8.1 htmlmin-0.1.12 imagehash-4.3.1 multimethod-1.9.1 pandas-profiling-3.6.6 phik-0.12.3 pydantic-1.10.11 tangled-up-in-unicode-0.2.0 typeguard-2.13.3 typing-extensions-4.7.1 visions-0.7.5 wordcloud-1.9.2 ydata-profiling-4.3.1
Note: you may need to restart the kernel to use updated packages.
  WARNING: The script wordcloud_cli.exe is installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
  WARNING: The script phik_trial.exe is installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
  WARNING: The script htmlmin.exe is installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
  WARNING: The scripts pandas_profiling.exe and ydata_profiling.exe are installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
  WARNING: The script pandas_profiling.exe is installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
In [2]:
conda install -c conda-forge pandas-profiling
Collecting package metadata (current_repodata.json): ...working... done
Solving environment: ...working... done

## Package Plan ##

  environment location: C:\ProgramData\Anaconda3

  added / updated specs:
    - pandas-profiling


The following packages will be downloaded:

    package                    |            build
    ---------------------------|-----------------
    conda-4.14.0               |   py39hcbf5309_0         1.0 MB  conda-forge
    pandas-profiling-1.4.1     |                0          40 KB  conda-forge
    python_abi-3.9             |           2_cp39           4 KB  conda-forge
    ------------------------------------------------------------
                                           Total:         1.1 MB

The following NEW packages will be INSTALLED:

  pandas-profiling   conda-forge/win-64::pandas-profiling-1.4.1-0
  python_abi         conda-forge/win-64::python_abi-3.9-2_cp39

The following packages will be UPDATED:

  conda              pkgs/main::conda-4.12.0-py39haa95532_0 --> conda-forge::conda-4.14.0-py39hcbf5309_0



Downloading and Extracting Packages

python_abi-3.9       | 4 KB      |            |   0% 
python_abi-3.9       | 4 KB      | ########## | 100% 
python_abi-3.9       | 4 KB      | ########## | 100% 

conda-4.14.0         | 1.0 MB    |            |   0% 
conda-4.14.0         | 1.0 MB    | ########## | 100% 
conda-4.14.0         | 1.0 MB    | ########## | 100% 

pandas-profiling-1.4 | 40 KB     |            |   0% 
pandas-profiling-1.4 | 40 KB     | ########## | 100% 
pandas-profiling-1.4 | 40 KB     | ########## | 100% 
Preparing transaction: ...working... done
Verifying transaction: ...working... failed

Note: you may need to restart the kernel to use updated packages.

==> WARNING: A newer version of conda exists. <==
  current version: 4.12.0
  latest version: 23.5.2

Please update conda by running

    $ conda update -n base -c defaults conda



EnvironmentNotWritableError: The current user does not have write permissions to the target environment.
  environment location: C:\ProgramData\Anaconda3


In [1]:
import numpy as np
import pandas as pd
In [2]:
from pandas_profiling import ProfileReport
C:\Users\gilda.tahani\AppData\Local\Temp\ipykernel_8084\2274191625.py:1: DeprecationWarning: `import pandas_profiling` is going to be deprecated by April 1st. Please use `import ydata_profiling` instead.
  from pandas_profiling import ProfileReport
In [4]:
data = pd.read_csv("Anime.csv")
In [5]:
data
Out[5]:
username anime_id my_score user_id gender title type source score scored_by rank popularity genre Duration Rating Members Favorites Completed On-Hold Dropped
0 karthiga 21 9 2255153 Female One Piece TV Manga 8.54 423868.0 91 35 Action, Adventure, Comedy, Super Power, Drama,... 24 min. per ep. R - 17+ (violence & profanity) 1251960 61971 718161 71513 26678
1 RedvelvetDaisuki 918 0 1897606 Female Gintama TV Manga 9.01 141830.0 15 95 Action, Sci-Fi, Comedy, Historical, Parody, Sa... 1 hr. 55 min. R - 17+ (violence & profanity) 273145 1174 208333 1935 770
2 RedvelvetDaisuki 9479 3 1897606 Female Coppelion TV Manga 6.54 37299.0 5443 949 Action, Sci-Fi, Seinen 24 min. per ep. PG-13 - Teens 13 or older 558913 12944 718161 71513 13925
3 RedvelvetDaisuki 22135 8 1897606 Female Ping Pong The Animation TV Manga 8.65 72887.0 58 563 Sports, Psychological, Drama, Seinen 25 min. per ep. PG-13 - Teens 13 or older 94683 587 718161 71513 5378
4 Damonashu 1829 6 37326 Male Gedo Senki Movie Novel 7.13 44087.0 3072 1125 Adventure, Fantasy, Magic 23 min. per ep. PG - Children 13224 18 718161 766 1108
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
4920 Sam_J 32696 6 26952 Male Fukigen na Mononokean TV Web manga 7.45 26464.0 1804 1253 Comedy, Demons, Supernatural 15 min. per ep. PG-13 - Teens 13 or older 148259 8 150183 112 100
4921 nikekid9387 343 7 68295 Male Tsukuyomi: Moon Phase TV Manga 7.10 21039.0 3218 1475 Comedy, Romance, Vampire, Fantasy, Seinen 15 min. PG-13 - Teens 13 or older 148259 12 150183 1935 104
4922 Retridemption 885 0 531285 Female Tenshi no Tamago OVA Original 7.63 20757.0 1282 1478 Fantasy, Dementia, Drama 24 min. per ep. PG-13 - Teens 13 or older 490554 8762 718161 12737 16529
4923 Retridemption 2369 7 531285 Female Rental Magica TV Light novel 7.14 15714.0 3053 1620 Mystery, Supernatural, Fantasy 15 min. per ep. PG - Children 382 0 718161 296 51
4924 Retridemption 4282 10 531285 Female Kara no Kyoukai 5: Mujun Rasen Movie Light novel 8.63 78701.0 65 594 Action, Mystery, Supernatural, Drama, Romance,... 16 min. PG - Children 335 0 208333 1935 118

4925 rows × 20 columns

In [6]:
profile = ProfileReport(data, title="Pandas Profiling Report")
In [7]:
data.profile_report()
Summarize dataset:   0%|          | 0/5 [00:00<?, ?it/s]
Generate report structure:   0%|          | 0/1 [00:00<?, ?it/s]
Render HTML:   0%|          | 0/1 [00:00<?, ?it/s]
Out[7]:

In [8]:
profile.to_file("EDA_report.html")
Summarize dataset:   0%|          | 0/5 [00:00<?, ?it/s]
Generate report structure:   0%|          | 0/1 [00:00<?, ?it/s]
Render HTML:   0%|          | 0/1 [00:00<?, ?it/s]
Export report to file:   0%|          | 0/1 [00:00<?, ?it/s]
In [ ]: